CASH FLOW BUDGET WORKSHEET SENSITIVITY ANALYSIS
(ASSUMES 5% CHANGE IN RECEIPTS AND DISBURSEMENTS)
Pessimistic Cash Flow
Expected Cash Flow
Optimistic Cash Flow
DIRECTIONS: Insert your cash flow information in the middle column entitled "EXPECTED CASH FLOW" Beginning Cash Balance $0 Cash Inflows (Income): Accts. Rec. Collections $19 Loan Proceeds $19 Sales & Receipts $19 Other: $0 $0 Total Cash Inflows $57 Available Cash Balance $57 Cash Outflows (Expenses): Advertising $0 Bank Service Charges $0 Contingencies $0 Credit Card Fees $0 Delivery Charges $0 Deposits $0 Dues & Subscriptions $0 Health Insurance $0 Insurance $0 Interest $0 Inventory Purchases $0 Lease Payments $0 Licenses & Permits $0 Miscellaneous $0 Office $0 Payroll $0 Payroll Taxes $0 Professional Fees $0 Rent or Lease $0 Repairs & Maintenance $0 Sales tax $0 Services $0 Signs $0 Supplies $0 Taxes & Licenses $0 Utilities & Telephone $21 Other: $0 $0 $0 Subtotal $21 Other Cash Out Flows: Capital Purchases Building Construction $0 Decorating $0 Fixtures & Equipment $0 Install Fixtures & Equip. $0 Remodeling $0 Lease Payments $0 Loan Principal $0 Owner's Draw $0 Other: $0 Subtotal $0 Total Cash Outflows $21 Ending Cash Balance $36 $0 $20 $20 $20 $0 $21 $21 $21 $0 $0 $63 $63 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $19 $0 $0 $0 $19
$60 $60
$20
$20
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $19 $44
$0 $20 $40
Page 1